OVERVIEW
Learning functions and formulas is only the beginning of becoming an Excel expert. Knowing the art of data management is an important part of using Excel to its full potential. This includes everything from understanding how to set up worksheets to managing data entry and maintaining good maintenance practices.
With this webinar, you will learn how to manage databases in Excel. Discover the tools that will make large amounts of data appear more manageable and easier to sort through and analyze. Understand which functions work best with large tables and how to use simple macros to automate repetitive tasks. Become a master of working with databases in Excel.
WHY SHOULD YOU ATTEND?
Microsoft Excel has become the de facto spreadsheet application for business. But do you ever feel like you’re drowning in data and can’t make heads or tails of it? This class will help you learn how to manage databases in Excel, and get the most out of them.
For 90-minutes, Excel expert Cathy Horwitz will lead you through a full array of powerful and easy-to-use database commands and methods critical to effectively working with Excel databases. In this webinar, you will learn how to improve your Excel database skills so that you can better summarize info-making better, more-informed business decisions.
LEARNING OBJECTIVES
You’ll learn how to cleverly use standard Excel functions that could save you hours through to days of manual work.
Easy-to-use methods to build and manage your database
Import a database from outside of Excel
Techniques to sort and filter data in order to identify business trends
Tips and tricks to validate your data and guarantee accuracy
Turn the database into a PivotTable to analyse the data
AREAS COVERED
Creating a Database in Excel
Setting up a database or list in Excel, Navigating your database, and Data Validation.
Data import and clean-up tools
Sorting, Multi-level sorting, Auto-Filter, Advanced Filters.
Summarizing Data – Subtotal Lists, Using Functions to summarize data.
Using Data Analysis – Pivot Tables
WHO WILL BENEFIT?
Anyone in companies that use computer systems –
Business Owners,
CEO’s / CFO’s / CTO’s
Managers, Accountants, CPA’s
Cost Accountants / Managerial Accountants
IT Professionals, Auditors
Human Resource Personnel
Bookkeepers, Marketers
Mergers & Acquisitions Specialists
Controllers, Investment Analysts
Financial Consultants, Financial Analysts
Risk Managers, Strategic Planners
Business Analysts, Forecasting & Planning Personnel
Capital Expenditure Planners
Anybody with large amounts of data
Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
Go to Event WebsiteAdvertisements